<%@ page import="java.sql.*"%>
<%@ include file="dbconn.jsp" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Request Portal</title>
<link href="/tros/menuMain.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width=100% bordercolor="#C6D4E1" bgcolor="#C6D4E1">
<tr><th scope="col"><div align="center"><h1 align="center"><font face="Times New Roman">Tros - Online Banking System </font></h1></div></th></tr>
</table>
<div id="overall" align="center">
<div id="dropdwn" align="center">
<ul>
<li><a href='adminHome.jsp'>Home</a>
</li>
</ul>
<ul>
<li><a href='custFunc.jsp?value=<%=session.getAttribute( "currentID" )%>'>Customers</a>
<ul>
<li><a href='addNewUser.jsp?value=<%=session.getAttribute( "currentID" )%>'>Add User</a></li>
</ul>
</li>                                   
</ul>
<ul>
<li><a href='reqPortal.jsp?value=<%=session.getAttribute( "currentID" )%>'>Customer Requests</a>
</li>
</ul>
<ul>
<li><a href='logout.jsp'>Log Out</a></li>
</ul>
<br class="flow" />
</div>
</div>
&nbsp;
&nbsp;
<fieldset>
<legend><b>New User </b></legend>
<h3 align=center> New User Requests </h3>
<p align=center>Listed below are the various New Customer Request </p>
<table width="1000px" align=center cellpadding=5 cellspacing=0 bgcolor="#D5FFD5" >
<tr><td>&nbsp;<td></tr>
<%

Statement req = connect.createStatement();
ResultSet result =req.executeQuery("SELECT * FROM NEWUSERS");
if(!result.next()){ 
	%>
	<tr><td><div align="center"><p>No New User Requests Available </div></td></tr>
  <% 
}
else{
%>
<tr><td align="right"><b> First Name </b></td>
<td align="center"><b> Email Id </b></td>
<tr>
<%
    do{
	    	  String fname=result.getString("FIRSTNAME");
		      String email=result.getString("EMAIL");   	      
	%>
	<tr><td align="right"><a href='perinfo.jsp?value=<%=fname%>'><%=fname %></a></td>
	<td align="center"><%=email %></td>
	<tr>
	<tr><td>&nbsp;</td></tr>
	<%
	    } 
	    while(result.next());
	}
	
result.close();
req.close();
connect.close();
%>
<tr><td colspan="6"><div align="center"><a href='adminHome.jsp?value=<%=session.getAttribute( "currentID" )%>'>Home</a></div></td></tr>
</table>
</fieldset>
</body>
</html>